Replication with no downtime – with Firebird 2.5 - 5.0
Our replication extension for Firebird 2.5–5.0 turns your database platform into a robust, flexibly scalable system – without the typical limitations of classic standard replication mechanisms. Whether you need high availability, a reporting database, geographical distribution or load balancing, you remain in control – even during live operation.
The solution can be integrated into existing third-party software that works with Firebird 2.5 - 5.0 and can also be marketed by software manufacturers as an enterprise feature to complement their own applications.
Advantages at a glance
1) Switch replication on and off at any time – with no downtime
Activate or deactivate replication during ongoing operation without having to stop the master database. This means that maintenance, testing, conversions or temporary shutdowns are possible without interrupting your productive processes.
2) Error-tolerant and fail-safe – continue working without any data loss
If the server running the replicated database fails, your system will continue to operate without any data loss. As soon as the target server is available again, the extension automatically restores replication and reliably synchronizes any changes that have been made in the meantime.
3) Scalable: One-to-many with no architectural changes
One master, multiple targets: Use the solution without any changes as 1:n replication (one master replicates to multiple targets) – ideal for reporting, read scaling, branch/location solutions or separate systems for analysis and operation.
4) Multi-master perspective – near-time synchronous or asynchronous
With targeted adjustments to your software – particularly when assigning primary keys – the solution can also be operated as synchronous or asynchronous near-time multi-master replication: writing is possible on every server, and all others then receive the changes. This allows you to lay the foundation for genuine distributed write scenarios and maximum availability.
IBExpert company workshops – implementation, source code and expertise included
IBExpert offers company workshops for precisely this solution, in which not only the basics are taught, but replication is also implemented specifically on your customer database – including clear documentation and operational setup.
What will be implemented and documented in the workshop
In the workshop, implementation will be individually tailored to your specific environment. This includes, among other things:
Integration of the solution with your customer database (Firebird 2.5 - 5.0)
Documentation of the customer-specific setup (operating and restart concept)
Provision of ready-to-use batch files, e.g. for:
Initialisation (initial synchronisation/initial setup of replication)
Starting the replication
Stopping replication
Backup/restore of the replicate (including restart after restore)
Optional: Standardised processes for replicate refresh and recovery
Remote training (up to 6 hours) included
Each workshop includes up to 6 hours of remote training, during which the system is activated on your actual customer database. The necessary expertise for subsequent operation (monitoring, troubleshooting, restart scenarios, update/maintenance procedures) is developed jointly during this training.
Important prerequisite (and alternative should it not be met)
Ideally, all tables which are to be replicated should have a primary key.
If this is not possible for certain reasons, we can also replicate such databases – including with Firebird 2.5 – 5.0, albeit using alternative technology developed in-house.
Source code & usage rights for workshop participants (user companies)
Workshop participants receive the complete source code.
The source code is provided in a form that is executable for Firebird 2.5 - 5.0.
The company may use the solution on its own computers/systems without any restrictions.
Source code & usage rights for software manufacturers/ISVs (marketing as an enterprise feature)
Software manufacturers may use the solution on up to 10 customer installations at no extra charge.
For more than 10 customer installations, an OEM price for resale can be obtained on request.
The result: greater availability, greater control, greater scope for growth.
Instead of treating replication as a rigid ‘on/off’ construct, you get a system that adapts to your operational reality: maintenance-friendly, fail-safe, scalable – and ready for sophisticated setups, right up to multi-master concepts.
Cost: EUR 4,999 (net of sales tax)
Contact us with absolutely no obligation! Contact our team at register@ibexpert.net or start a personal Signal chat directly:
Free Versions
IBExpert Developer Studio Personal Edition
The IBExpert Personal Edition is a free version of the IBExpert Developer Studio software that we offer to our customers for personal use. It includes access to the IBExpert IDE. (All other IBExpert Developer Studio modules are available in the IBExpert Developer Studio full version.) Details
IBExpert Benchmark Tool - Free special version
Compare your computer performance and test the speed of your Firebird Windows server with the free IBExpert Benchmark Tool. Details
IBExpert Developer Studio Educational Edition
If you would like to use IBExpert in your classroom, we offer the free IBExpert Developer Studio Educational Edition. This edition is equivalent to the IBExpert Developer Studio Edition, but is limited to a 50 MB database size and time-limited usage. Details
Remove the IBExpert Developer Studio software activation
You should only remove the software registration if you have a valid software subscription.
Open your registered IBExpert Developer Studio Edition, open the About window in the Help menu. Click the Remove activation link in the bottom right-hand corner and confirm. A message appears displaying the remove activation string.
Click OK in order to open your email client. If your computer settings do not allow this, you can write a mail to register@ibexpert.net, and simply paste the clipboard content into the subject heading. If you do not have an email client installed on the machine, then please mail us a screenshot of the Remove Activation string.
IBExpert software
Creating an IBExpert Download Center account
Forgotten your password for your IBExpert Download Center user account
Downloading and installing the IBExpert software
Activating your software registration
IBExpert User Database
Registering a database
Remove the IBExpert Developer Studio software activation
Further information regarding working with IBExpert and Firebird can be found in our IBExpert Firebird Learning Center and our online documentation.
If you still cannot find an answer to your query, please do not hesitate to contact us.
Firebird SQL und Pascalprogrammierung für die Next Generation
Drei intensive Schulungstage für die nächste Entwicklergeneration: Die Teilnehmer lernen, wie Pascal-Projekte mit Delphi und Lazarus aufgebaut sind, wie Firebird-Datenbanken funktionieren und wie beides in IBExpert professionell zusammengeführt wird.
Im Mittelpunkt stehen nicht theoretische Sprachdetails, sondern das Wissen, das junge Entwickler benötigen, um in bestehenden Unternehmensprojekten produktiv mitarbeiten zu können - einschließlich des sinnvollen und verantwortungsbewussten Einsatzes von KI-Werkzeugen wie ChatGPT und Codex.
Weitere Information: https://ibexpert.net/cms/training#German
Anmeldung an register@ibexpert.net
Diese 3-tägige Praxisschulung kann auch als Remote- oder Onsite-Firmenschulung, in der wir dann Ihre schon existierende Software und Datenbank als Basis nehmen, gebucht werden.
Für die nächste Entwicklergeneration
Nicht als Rückblick auf alte Entwicklungswelten, sondern als praxisnaher Einstieg für Menschen, die künftig produktiv an bestehenden Systemen mitarbeiten sollen. Keine praktische Erfahrung mit Delphi, Lazarus, Firebird oder IBExpert erforderlich.
Geeignet für
|
Empfohlene Voraussetzungen
|
Firebird performance issues
How do you measure the performance of your own server or your clients'? Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs?
The IBExpert Benchmark is a simple but effective tool, which gives you a reference benchmark, based on our recommended IFS Servers. Using IBExpert Benchmark you can generate and compare a reproducible speed index for your Firebird Server hardware. On average, our IFS servers with Firebird are 5 to 10 times faster than the server or virtual machines that our customers have previously used.
Perform the comparison yourself using our free IBExpert benchmark software on your Firebird server: https://ibexpert.net/benchmark/setup_benchmark.exe